Imports Microsoft.VisualBasic
Imports System.Data
Imports System.Data.SqlClient
Imports System.IO
Imports System.Web.UI.Page

Public Class clsNotificacionSIVISTRA

#Region "Variables"
    Private _FechaCreacionRegistro As DateTime
    Private _idtblpersona As Integer
    Private _idTblEntidadUPGD_UI As Integer
    Private _idTblSubsistemas As Integer
    Private _id_subred As Integer
    Private _servicio As Integer
    Private _servicio_Otro_Cual As String = ""
    Private _chkAccidente As Boolean = 0
    Private _chkEnfermedadCondMorbida As Boolean = 0
    Private _chkExposicionQuimicos As Boolean = 0
    'Private _chkCondicionesBiomecanicas As Boolean = 0
    Private _chkExposicionAgroquimicos As Boolean = 0
    Private _chkotroEvento As Boolean = 0
    Private _otroEventoCual As String = ""
    Private _FechaNotificacion As String = ""
    Private _id_TipoIdentificacion As String = ""
    Private _NroIdentificacion As String = ""
    Private _PrimerNombre As String = ""
    Private _SegundoNombre As String = ""
    Private _PrimerApellido As String = ""
    Private _SegundoApellido As String = ""
    Private _FechaNacimiento As String = ""
    Private _Edad As Byte
    Private _Sexo As Integer
    Private _IdTblDepartamentoResidencia As Integer
    Private _IdTblMunicipioResidencia As Integer
    Private _DireccionResidencia As String = ""
    Private _TelefonoPacTrab As String = ""
    Private _EstratoPacTrab As Integer
    Private _IdTblOcupacion As Integer
    Private _Id_RegimenSalud As String = ""
    Private _tipoAfiliacion As String = ""
    Private _IdTblEntidadAdministradora As Integer
    Private _Id_Etnia As String = ""
    Private _GP_Discapacitados As Boolean = 0
    Private _GP_Gestantes As Boolean = 0
    Private _SemanaGestacion As Integer = 0
    Private _GP_Desmovilizados As Boolean = 0
    Private _GP_Desplazados As Boolean = 0
    Private _GP_HabitantesCalle As Boolean = 0
    Private _GP_CentrosPsiq As Boolean = 0
    Private _GP_Migrantes As Boolean = 0
    Private _GP_ICBF As Boolean = 0
    Private _GP_VictimasViolenciaArmada As Boolean = 0
    Private _GP_Carcelarios As Boolean = 0
    Private _GP_MadresComuni As Boolean = 0
    Private _GP_Otros As Boolean = 0
    Private _FuenteInformacion As Integer
    Private _IdtblSivigilaDCPaisesISO3166 As Integer
    Private _IdTblDepartamentoProcedencia As Integer
    Private _IdTblMunicipioProcedencia As Integer
    Private _Id_AreaProcedencia As String = ""
    Private _direccionUTI As String = ""
    Private _X_Proced As Double
    Private _Y_Proced As Double
    Private _Id_LocalidadProced As Integer
    Private _Id_BarrioProced As Integer
    Private _BarrioOcurrDigitado As String = ""
    Private _Id_tblupzProced As Integer
    Private _veredaZona As String = ""
    Private _nombreUTI As String = ""
    Private _telefonoUTI As String = ""
    Private _celularUTI As String = ""
    Private _FechaConsulta As String = ""
    Private _FechaSintomas As String = ""
    Private _CodigoCIE10 As String = ""
    Private _DescripcionEvento As String = ""
    Private _Id_ClasificacionCaso As String = ""
    Private _Hospitalizado As Byte
    Private _FechaHospitalizacion As String
    Private _CondicionFinal As String = ""
    Private _FechaDefuncion As String = ""
    Private _CertificadoDefuncion As String = ""
    Private _CausaBasica As String = ""
    Private _NombreProfesional As String = ""
    Private _TelefonoProfesional As String = ""
    Private _CuentaconArl As String = ""
    Private _CuentaDocIdentidad As String = ""
    Private _CuentaNombres As String = ""
    Private _CuentaDireccionTelefono As String = ""
    Private _CumpleDatCompl As String = ""
    Private _CategoriaUTlsAE As Integer
    Private _CalificacionPrioridad As Integer
    Private _ProgramarVisita As Byte
    Private _FechaUltimaVisitaIEC As String = ""
    Private _ResultadoVisita As Integer
    Private _motivoCasoDescartado As Integer
    Private _CualOtroCasoDescartado As String = ""
    Private _ObservacionesNotDatComple As String = ""
    Private _AccidenteDatCompl As Byte
    Private _EnfermedadDatCompl As Byte
    Private _CQuimicoDatCompl As Byte
    Private _CBiomecanicaDatCompl As Byte
    Private _CAgroquimicoDatCompl As Byte
    Private _OtroEventoDatCompl As Byte
    Private _OtroEventoCualDatCompl As String = ""
    Private _HallaRecoSugeDatCompl As String = ""
    Private _FuenteRutinaria As Boolean = 0
    Private _FuenteInst As Boolean = 0
    Private _FuenteComu As Boolean = 0


#End Region
#Region "Propiedades"

    Property FechaCreacionRegistro As DateTime
        Get
            Return _FechaCreacionRegistro
        End Get
        Set(ByVal value As DateTime)
            _FechaCreacionRegistro = value
        End Set
    End Property

    Property idtblpersona As Integer
        Get
            Return _idtblpersona
        End Get
        Set(ByVal value As Integer)
            _idtblpersona = value
        End Set
    End Property

    Property idTblEntidadUPGD_UI As Integer
        Get
            Return _idTblEntidadUPGD_UI
        End Get
        Set(ByVal value As Integer)
            _idTblEntidadUPGD_UI = value
        End Set
    End Property

    Property idTblSubsistemas As Integer
        Get
            Return _idTblSubsistemas
        End Get
        Set(ByVal value As Integer)
            _idTblSubsistemas = value
        End Set
    End Property

    Property idsubred As Integer
        Get
            Return _id_subred
        End Get
        Set(ByVal value As Integer)
            _id_subred = value
        End Set
    End Property

    Property servicio As Integer
        Get
            Return _servicio
        End Get
        Set(ByVal value As Integer)
            _servicio = value
        End Set
    End Property

    Property servicioOtroCual As String
        Get
            Return _servicio_Otro_Cual
        End Get
        Set(ByVal value As String)
            _servicio_Otro_Cual = value
        End Set
    End Property

    Property chkAccidente As Boolean
        Get
            Return _chkAccidente
        End Get
        Set(ByVal value As Boolean)
            _chkAccidente = value
        End Set
    End Property

    Property chkEnfermedadCondMorbida As Boolean
        Get
            Return _chkEnfermedadCondMorbida
        End Get
        Set(ByVal value As Boolean)
            _chkEnfermedadCondMorbida = value
        End Set
    End Property

    Property chkExposicionQuimicos As Boolean
        Get
            Return _chkExposicionQuimicos
        End Get
        Set(ByVal value As Boolean)
            _chkExposicionQuimicos = value
        End Set
    End Property

    'Property chkCondicionesBiomecanicas As Boolean
    '    Get
    '        Return _chkCondicionesBiomecanicas
    '    End Get
    '    Set(ByVal value As Boolean)
    '        _chkCondicionesBiomecanicas = value
    '    End Set
    'End Property

    Property chkExposicionAgroquimicos As Boolean
        Get
            Return _chkExposicionAgroquimicos
        End Get
        Set(ByVal value As Boolean)
            _chkExposicionAgroquimicos = value
        End Set
    End Property

    Property chkotroEvento As Boolean
        Get
            Return _chkotroEvento
        End Get
        Set(ByVal value As Boolean)
            _chkotroEvento = value
        End Set
    End Property

    Property otroEventoCual As String
        Get
            Return _otroEventoCual
        End Get
        Set(ByVal value As String)
            _otroEventoCual = value
        End Set
    End Property

    Property FechaNotificacion As String
        Get
            Return _FechaNotificacion
        End Get
        Set(ByVal value As String)
            _FechaNotificacion = value
        End Set
    End Property


    Property id_TipoIdentificacion As String
        Get
            Return _id_TipoIdentificacion
        End Get
        Set(ByVal value As String)
            _id_TipoIdentificacion = value
        End Set
    End Property

    Property NroIdentificacion As String
        Get
            Return _NroIdentificacion
        End Get
        Set(ByVal value As String)
            _NroIdentificacion = value
        End Set
    End Property

    Property PrimerNombre As String
        Get
            Return _PrimerNombre
        End Get
        Set(ByVal value As String)
            _PrimerNombre = value
        End Set
    End Property

    Property SegundoNombre As String
        Get
            Return _SegundoNombre
        End Get
        Set(ByVal value As String)
            _SegundoNombre = value
        End Set
    End Property

    Property PrimerApellido As String
        Get
            Return _PrimerApellido
        End Get
        Set(ByVal value As String)
            _PrimerApellido = value
        End Set
    End Property

    Property SegundoApellido As String
        Get
            Return _SegundoApellido
        End Get
        Set(ByVal value As String)
            _SegundoApellido = value
        End Set
    End Property

    Property FechaNacimiento As String
        Get
            Return _FechaNacimiento
        End Get
        Set(ByVal value As String)
            _FechaNacimiento = value
        End Set
    End Property

    Property Edad As Byte
        Get
            Return _Edad
        End Get
        Set(ByVal value As Byte)
            _Edad = value
        End Set
    End Property

    Property Sexo As Integer
        Get
            Return _Sexo
        End Get
        Set(ByVal value As Integer)
            _Sexo = value
        End Set
    End Property

    Property IdTblDepartamentoResidencia As Integer
        Get
            Return _IdTblDepartamentoResidencia
        End Get
        Set(ByVal value As Integer)
            _IdTblDepartamentoResidencia = value
        End Set
    End Property

    Property IdTblMunicipioResidencia As Integer
        Get
            Return _IdTblMunicipioResidencia
        End Get
        Set(ByVal value As Integer)
            _IdTblMunicipioResidencia = value
        End Set
    End Property

    Property DireccionResidencia As String
        Get
            Return _DireccionResidencia
        End Get
        Set(ByVal value As String)
            _DireccionResidencia = value
        End Set
    End Property

    Property TelefonoPacTrab As String
        Get
            Return _TelefonoPacTrab
        End Get
        Set(ByVal value As String)
            _TelefonoPacTrab = value
        End Set
    End Property

    Property EstratoPacTrab As Integer
        Get
            Return _EstratoPacTrab
        End Get
        Set(ByVal value As Integer)
            _EstratoPacTrab = value
        End Set
    End Property

    Property IdTblOcupacion As Integer
        Get
            Return _IdTblOcupacion
        End Get
        Set(ByVal value As Integer)
            _IdTblOcupacion = value
        End Set
    End Property

    Property Id_RegimenSalud As String
        Get
            Return _Id_RegimenSalud
        End Get
        Set(ByVal value As String)
            _Id_RegimenSalud = value
        End Set
    End Property

    Property tipoAfiliacion As String
        Get
            Return _tipoAfiliacion
        End Get
        Set(ByVal value As String)
            _tipoAfiliacion = value
        End Set
    End Property

    Property IdTblEntidadAdministradora As Integer
        Get
            Return _IdTblEntidadAdministradora
        End Get
        Set(ByVal value As Integer)
            _IdTblEntidadAdministradora = value
        End Set
    End Property

    Property Id_Etnia As String
        Get
            Return _Id_Etnia
        End Get
        Set(ByVal value As String)
            _Id_Etnia = value
        End Set
    End Property

    Property GP_Discapacitados As Boolean
        Get
            Return _GP_Discapacitados
        End Get
        Set(ByVal value As Boolean)
            _GP_Discapacitados = value
        End Set
    End Property

    Property GP_Gestantes As Boolean
        Get
            Return _GP_Gestantes
        End Get
        Set(ByVal value As Boolean)
            _GP_Gestantes = value
        End Set
    End Property

    Property SemanaGestacion As Integer
        Get
            Return _SemanaGestacion
        End Get
        Set(ByVal value As Integer)
            _SemanaGestacion = value
        End Set
    End Property

    Property GP_Desmovilizados As Boolean
        Get
            Return _GP_Desmovilizados
        End Get
        Set(ByVal value As Boolean)
            _GP_Desmovilizados = value
        End Set
    End Property

    Property GP_Desplazados As Boolean
        Get
            Return _GP_Desplazados
        End Get
        Set(ByVal value As Boolean)
            _GP_Desplazados = value
        End Set
    End Property

    Property GP_HabitantesCalle As Boolean
        Get
            Return _GP_HabitantesCalle
        End Get
        Set(ByVal value As Boolean)
            _GP_HabitantesCalle = value
        End Set
    End Property

    Property GP_CentrosPsiq As Boolean
        Get
            Return _GP_CentrosPsiq
        End Get
        Set(ByVal value As Boolean)
            _GP_CentrosPsiq = value
        End Set
    End Property

    Property GP_Migrantes As Boolean
        Get
            Return _GP_Migrantes
        End Get
        Set(ByVal value As Boolean)
            _GP_Migrantes = value
        End Set
    End Property

    Property GP_ICBF As Boolean
        Get
            Return _GP_ICBF
        End Get
        Set(ByVal value As Boolean)
            _GP_ICBF = value
        End Set
    End Property

    Property GP_VictimasViolenciaArmada As Boolean
        Get
            Return _GP_VictimasViolenciaArmada
        End Get
        Set(ByVal value As Boolean)
            _GP_VictimasViolenciaArmada = value
        End Set
    End Property

    Property GP_Carcelarios As Boolean
        Get
            Return _GP_Carcelarios
        End Get
        Set(ByVal value As Boolean)
            _GP_Carcelarios = value
        End Set
    End Property

    Property GP_MadresComuni As Boolean
        Get
            Return _GP_MadresComuni
        End Get
        Set(ByVal value As Boolean)
            _GP_MadresComuni = value
        End Set
    End Property

    Property GP_Otros As Boolean
        Get
            Return _GP_Otros
        End Get
        Set(ByVal value As Boolean)
            _GP_Otros = value
        End Set
    End Property


    Property FuenteInformacion As Integer
        Get
            Return _FuenteInformacion
        End Get
        Set(ByVal value As Integer)
            _FuenteInformacion = value
        End Set
    End Property

    Property IdtblSivigilaDCPaisesISO3166 As Integer
        Get
            Return _IdtblSivigilaDCPaisesISO3166
        End Get
        Set(ByVal value As Integer)
            _IdtblSivigilaDCPaisesISO3166 = value
        End Set
    End Property

    Property IdTblDepartamentoProcedencia As Integer
        Get
            Return _IdTblDepartamentoProcedencia
        End Get
        Set(ByVal value As Integer)
            _IdTblDepartamentoProcedencia = value
        End Set
    End Property

    Property IdTblMunicipioProcedencia As Integer
        Get
            Return _IdTblMunicipioProcedencia
        End Get
        Set(ByVal value As Integer)
            _IdTblMunicipioProcedencia = value
        End Set
    End Property

    Property Id_AreaProcedencia As String
        Get
            Return _Id_AreaProcedencia
        End Get
        Set(ByVal value As String)
            _Id_AreaProcedencia = value
        End Set
    End Property

    Property direccionUTI As String
        Get
            Return _direccionUTI
        End Get
        Set(ByVal value As String)
            _direccionUTI = value
        End Set
    End Property

    Property X_Proced As Double
        Get
            Return _X_Proced
        End Get
        Set(ByVal value As Double)
            _X_Proced = value
        End Set
    End Property

    Property Y_Proced As Double
        Get
            Return _Y_Proced
        End Get
        Set(ByVal value As Double)
            _Y_Proced = value
        End Set
    End Property

    Property Id_LocalidadProced As Integer
        Get
            Return _Id_LocalidadProced
        End Get
        Set(ByVal value As Integer)
            _Id_LocalidadProced = value
        End Set
    End Property

    Property Id_BarrioProced As Integer
        Get
            Return _Id_BarrioProced
        End Get
        Set(ByVal value As Integer)
            _Id_BarrioProced = value
        End Set
    End Property

    Property BarrioOcurrDigitado As String
        Get
            Return _BarrioOcurrDigitado
        End Get
        Set(ByVal value As String)
            _BarrioOcurrDigitado = value
        End Set
    End Property

    Property Id_tblupzProced As Integer
        Get
            Return _Id_tblupzProced
        End Get
        Set(ByVal value As Integer)
            _Id_tblupzProced = value
        End Set
    End Property

    Property veredaZona As String
        Get
            Return _veredaZona
        End Get
        Set(ByVal value As String)
            _veredaZona = value
        End Set
    End Property

    Property nombreUTI As String
        Get
            Return _nombreUTI
        End Get
        Set(ByVal value As String)
            _nombreUTI = value
        End Set
    End Property

    Property telefonoUTI As String
        Get
            Return _telefonoUTI
        End Get
        Set(ByVal value As String)
            _telefonoUTI = value
        End Set
    End Property

    Property celularUTI As String
        Get
            Return _celularUTI
        End Get
        Set(ByVal value As String)
            _celularUTI = value
        End Set
    End Property

    Property FechaConsulta As String
        Get
            Return _FechaConsulta
        End Get
        Set(ByVal value As String)
            _FechaConsulta = value
        End Set
    End Property

    Property FechaSintomas As String
        Get
            Return _FechaSintomas
        End Get
        Set(ByVal value As String)
            _FechaSintomas = value
        End Set
    End Property

    Property CodigoCIE10 As String
        Get
            Return _CodigoCIE10
        End Get
        Set(ByVal value As String)
            _CodigoCIE10 = value
        End Set
    End Property

    Property DescripcionEvento As String
        Get
            Return _DescripcionEvento
        End Get
        Set(ByVal value As String)
            _DescripcionEvento = value
        End Set
    End Property

    Property Id_ClasificacionCaso As String
        Get
            Return _Id_ClasificacionCaso
        End Get
        Set(ByVal value As String)
            _Id_ClasificacionCaso = value
        End Set
    End Property

    Property Hospitalizado As Byte
        Get
            Return _Hospitalizado
        End Get
        Set(ByVal value As Byte)
            _Hospitalizado = value
        End Set
    End Property

    Property FechaHospitalizacion As String
        Get
            Return _FechaHospitalizacion
        End Get
        Set(ByVal value As String)
            _FechaHospitalizacion = value
        End Set
    End Property

    Property CondicionFinal As String
        Get
            Return _CondicionFinal
        End Get
        Set(ByVal value As String)
            _CondicionFinal = value
        End Set
    End Property

    Property FechaDefuncion As String
        Get
            Return _FechaDefuncion
        End Get
        Set(ByVal value As String)
            _FechaDefuncion = value
        End Set
    End Property

    Property CertificadoDefuncion As String
        Get
            Return _CertificadoDefuncion
        End Get
        Set(ByVal value As String)
            _CertificadoDefuncion = value
        End Set
    End Property

    Property CausaBasica As String
        Get
            Return _CausaBasica
        End Get
        Set(ByVal value As String)
            _CausaBasica = value
        End Set
    End Property

    Property NombreProfesional As String
        Get
            Return _NombreProfesional
        End Get
        Set(ByVal value As String)
            _NombreProfesional = value
        End Set
    End Property

    Property TelefonoProfesional As String
        Get
            Return _TelefonoProfesional
        End Get
        Set(ByVal value As String)
            _TelefonoProfesional = value
        End Set
    End Property


    Property CuentaconArl As String
        Get
            Return _CuentaconArl
        End Get
        Set(ByVal value As String)
            _CuentaconArl = value
        End Set
    End Property

    Property CuentaDocIdentidad As String
        Get
            Return _CuentaDocIdentidad
        End Get
        Set(ByVal value As String)
            _CuentaDocIdentidad = value
        End Set
    End Property

    Property CuentaNombres As String
        Get
            Return _CuentaNombres
        End Get
        Set(ByVal value As String)
            _CuentaNombres = value
        End Set
    End Property

    Property CuentaDireccionTelefono As String
        Get
            Return _CuentaDireccionTelefono
        End Get
        Set(ByVal value As String)
            _CuentaDireccionTelefono = value
        End Set
    End Property

    Property CumpleDatCompl As String
        Get
            Return _CumpleDatCompl
        End Get
        Set(ByVal value As String)
            _CumpleDatCompl = value
        End Set
    End Property

    Property CategoriaUTlsAE As Integer
        Get
            Return _CategoriaUTlsAE
        End Get
        Set(ByVal value As Integer)
            _CategoriaUTlsAE = value
        End Set
    End Property

    Property CalificacionPrioridad As Integer
        Get
            Return _CalificacionPrioridad
        End Get
        Set(ByVal value As Integer)
            _CalificacionPrioridad = value
        End Set
    End Property

    Property ProgramarVisita As Byte
        Get
            Return _ProgramarVisita
        End Get
        Set(ByVal value As Byte)
            _ProgramarVisita = value
        End Set
    End Property

    Property FechaUltimaVisitaIEC As String
        Get
            Return _FechaUltimaVisitaIEC
        End Get
        Set(ByVal value As String)
            _FechaUltimaVisitaIEC = value
        End Set
    End Property

    Property ResultadoVisita As Integer
        Get
            Return _ResultadoVisita
        End Get
        Set(ByVal value As Integer)
            _ResultadoVisita = value
        End Set
    End Property

    Property motivoCasoDescartado As Integer
        Get
            Return _motivoCasoDescartado
        End Get
        Set(ByVal value As Integer)
            _motivoCasoDescartado = value
        End Set
    End Property

    Property CualOtroCasoDescartado As String
        Get
            Return _CualOtroCasoDescartado
        End Get
        Set(ByVal value As String)
            _CualOtroCasoDescartado = value
        End Set
    End Property

    Property ObservacionesNotDatComple As String
        Get
            Return _ObservacionesNotDatComple
        End Get
        Set(ByVal value As String)
            _ObservacionesNotDatComple = value
        End Set
    End Property

    Property AccidenteDatCompl As Byte
        Get
            Return _AccidenteDatCompl
        End Get
        Set(ByVal value As Byte)
            _AccidenteDatCompl = value
        End Set
    End Property

    Property EnfermedadDatCompl As Byte
        Get
            Return _EnfermedadDatCompl
        End Get
        Set(ByVal value As Byte)
            _EnfermedadDatCompl = value
        End Set
    End Property

    Property CQuimicoDatCompl As Byte
        Get
            Return _CQuimicoDatCompl
        End Get
        Set(ByVal value As Byte)
            _CQuimicoDatCompl = value
        End Set
    End Property

    Property CBiomecanicaDatCompl As Byte
        Get
            Return _CBiomecanicaDatCompl
        End Get
        Set(ByVal value As Byte)
            _CBiomecanicaDatCompl = value
        End Set
    End Property

    Property CAgroquimicoDatCompl As Byte
        Get
            Return _CAgroquimicoDatCompl
        End Get
        Set(ByVal value As Byte)
            _CAgroquimicoDatCompl = value
        End Set
    End Property

    Property OtroEventoDatCompl As Byte
        Get
            Return _OtroEventoDatCompl
        End Get
        Set(ByVal value As Byte)
            _OtroEventoDatCompl = value
        End Set
    End Property

    Property OtroEventoCualDatCompl As String
        Get
            Return _OtroEventoCualDatCompl
        End Get
        Set(ByVal value As String)
            _OtroEventoCualDatCompl = value
        End Set
    End Property

    Property HallaRecoSugeDatCompl As String
        Get
            Return _HallaRecoSugeDatCompl
        End Get
        Set(ByVal value As String)
            _HallaRecoSugeDatCompl = value
        End Set
    End Property

    Property FuenteRutinaria As Boolean
        Get
            Return _FuenteRutinaria
        End Get
        Set(ByVal value As Boolean)
            _FuenteRutinaria = value
        End Set
    End Property

    Property FuenteInst As Boolean
        Get
            Return _FuenteInst
        End Get
        Set(ByVal value As Boolean)
            _FuenteInst = value
        End Set
    End Property

    Property FuenteComu As Boolean
        Get
            Return _FuenteComu
        End Get
        Set(ByVal value As Boolean)
            _FuenteComu = value
        End Set
    End Property

#End Region

#Region "Metodos"

    Public Function InsertNotificacionSIVISTRA() As clsServiceSIVISTRA
        Dim oResp As New clsServiceSIVISTRA
        Dim objSession As HttpSessionState = HttpContext.Current.Session

        oResp.CodError = 0
        oResp.TextoError = ""

        Try
            Dim Objparametros As New Collection

            Dim ObjItems = New CmdParametro("@IdTblEntidad", Me.idTblEntidadUPGD_UI, SqlDbType.Int, False)
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("idTblSubsistemas", objSession("IdSubsistema"), SqlDbType.Int, False)
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("id_subred", objSession("IdEntidad"), SqlDbType.Int, False)
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("servicio", Me.servicio, SqlDbType.Int, False)
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("servicio_Otro_Cual", Me.servicioOtroCual, SqlDbType.VarChar, 30, False)
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("chkAccidente", Me.chkAccidente, SqlDbType.Bit, False)
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("chkEnfermedadCondMorbida", Me.chkEnfermedadCondMorbida, SqlDbType.Bit, False)
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("chkExposicionQuimicos", Me.chkExposicionQuimicos, SqlDbType.Bit, False)
            Objparametros.Add(ObjItems)

            'ObjItems = New CmdParametro("chkCondicionesBiomecanicas", Me.chkCondicionesBiomecanicas, SqlDbType.Bit, False)
            'Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("chkExposicionAgroquimicos", Me.chkExposicionAgroquimicos, SqlDbType.Bit, False)
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("chkotroEvento", Me.chkotroEvento, SqlDbType.Bit, False)
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("otroEventoCual", Me.otroEventoCual, SqlDbType.VarChar, 200, False)
            Objparametros.Add(ObjItems)

            If Me.FechaNotificacion <> "" Then
                ObjItems = New CmdParametro("@FechaNotificacion", CDate(Me.FechaNotificacion), SqlDbType.DateTime, False)
            Else
                ObjItems = New CmdParametro("@FechaNotificacion", DBNull.Value, SqlDbType.SmallDateTime, False)
            End If
            Objparametros.Add(ObjItems)

            If Me.id_TipoIdentificacion <> 0 Then
                ObjItems = New CmdParametro("id_TipoIdentificacion", Me.id_TipoIdentificacion, SqlDbType.Char, 10, False)
            Else
                ObjItems = New CmdParametro("id_TipoIdentificacion", DBNull.Value, SqlDbType.Char, 10, False)
            End If
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("NroIdentificacion", Me.NroIdentificacion, SqlDbType.VarChar, 21, False)
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("PrimerNombre", Me.PrimerNombre, SqlDbType.VarChar, 20, False)
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("SegundoNombre", Me.SegundoNombre, SqlDbType.VarChar, 30, False)
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("PrimerApellido", Me.PrimerApellido, SqlDbType.VarChar, 20, False)
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("SegundoApellido", Me.SegundoApellido, SqlDbType.VarChar, 30, False)
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("FechaNacimiento", CDate(Me.FechaNacimiento), SqlDbType.SmallDateTime, False)
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("Edad", Me.Edad, SqlDbType.TinyInt, False)
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("Sexo", Me.Sexo, SqlDbType.Int, False)
            Objparametros.Add(ObjItems)

            Dim InsertarPersonaSIVISTRA As String = validarPersonaSIVISTRA(Me._PrimerNombre.ToUpper, Me._SegundoNombre.ToUpper, Me._PrimerApellido.ToUpper, Me._SegundoApellido.ToUpper, Me._NroIdentificacion, Me._id_TipoIdentificacion, CDate(Me._FechaNacimiento))

            ObjItems = New CmdParametro("@IdTblUsuarioCreoRegistro", objSession("IdUsuario"), SqlDbType.Int, False)
            Objparametros.Add(ObjItems)

            If Me.IdTblDepartamentoResidencia <> 0 Then
                ObjItems = New CmdParametro("IdTblDepartamentoResidencia", Me.IdTblDepartamentoResidencia, SqlDbType.Int, False)
            Else
                ObjItems = New CmdParametro("IdTblDepartamentoResidencia", DBNull.Value, SqlDbType.Int, False)
            End If
            Objparametros.Add(ObjItems)

            If Me.IdTblMunicipioResidencia <> 0 Then
                ObjItems = New CmdParametro("IdTblMunicipioResidencia", Me.IdTblMunicipioResidencia, SqlDbType.Int, False)
            Else
                ObjItems = New CmdParametro("IdTblMunicipioResidencia", DBNull.Value, SqlDbType.Int, False)
            End If
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("DireccionResidencia", Me.DireccionResidencia, SqlDbType.VarChar, 120, False)
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("TelefonoPacTrab", Me.TelefonoPacTrab, SqlDbType.Char, 12, False)
            Objparametros.Add(ObjItems)

            If Me.EstratoPacTrab <> 0 Then
                ObjItems = New CmdParametro("EstratoPacTrab", Me.EstratoPacTrab, SqlDbType.Int, False)
            Else
                ObjItems = New CmdParametro("EstratoPacTrab", DBNull.Value, SqlDbType.Int, False)
            End If
            Objparametros.Add(ObjItems)

            If Me.IdTblOcupacion <> 0 Then
                ObjItems = New CmdParametro("IdTblOcupacion", Me.IdTblOcupacion, SqlDbType.Int, False)
            Else
                ObjItems = New CmdParametro("IdTblOcupacion", DBNull.Value, SqlDbType.Int, False)
            End If
            Objparametros.Add(ObjItems)

            If Me.Id_RegimenSalud <> 0 Then
                ObjItems = New CmdParametro("Id_RegimenSalud", Me.Id_RegimenSalud, SqlDbType.Char, 10, False)
            Else
                ObjItems = New CmdParametro("Id_RegimenSalud", DBNull.Value, SqlDbType.Char, 10, False)
            End If
            Objparametros.Add(ObjItems)

            If Me.tipoAfiliacion <> 0 Then
                ObjItems = New CmdParametro("tipoAfiliacion", Me.tipoAfiliacion, SqlDbType.Char, 1, False)
            Else
                ObjItems = New CmdParametro("tipoAfiliacion", DBNull.Value, SqlDbType.Char, 1, False)
            End If
            Objparametros.Add(ObjItems)

            If Me.IdTblEntidadAdministradora <> 0 Then
                ObjItems = New CmdParametro("IdTblEntidadAdministradora", Me.IdTblEntidadAdministradora, SqlDbType.Int, False)
            Else
                ObjItems = New CmdParametro("IdTblEntidadAdministradora", DBNull.Value, SqlDbType.Int, False)
            End If
            Objparametros.Add(ObjItems)

            If Me.Id_Etnia <> 0 Then
                ObjItems = New CmdParametro("Id_Etnia", Me.Id_Etnia, SqlDbType.Char, 10, False)
            Else
                ObjItems = New CmdParametro("Id_Etnia", DBNull.Value, SqlDbType.Char, 10, False)
            End If
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("GP_Discapacitados", Me.GP_Discapacitados, SqlDbType.Bit, False)
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("GP_Gestantes", Me.GP_Gestantes, SqlDbType.Bit, False)
            Objparametros.Add(ObjItems)

            If Me.SemanaGestacion <> 0 Then
                ObjItems = New CmdParametro("SemanaGestacion", Me.SemanaGestacion, SqlDbType.TinyInt, False)
            Else
                ObjItems = New CmdParametro("SemanaGestacion", DBNull.Value, SqlDbType.TinyInt, False)
            End If

            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("GP_Desmovilizados", Me.GP_Desmovilizados, SqlDbType.Bit, False)
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("GP_Desplazados", Me.GP_Desplazados, SqlDbType.Bit, False)
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("GP_HabitantesCalle", Me.GP_HabitantesCalle, SqlDbType.Bit, False)
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("GP_CentrosPsiq", Me.GP_CentrosPsiq, SqlDbType.Bit, False)
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("GP_Migrantes", Me.GP_Migrantes, SqlDbType.Bit, False)
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("GP_ICBF", Me.GP_ICBF, SqlDbType.Bit, False)
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("GP_VictimasViolenciaArmada", Me.GP_VictimasViolenciaArmada, SqlDbType.Bit, False)
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("GP_Carcelarios", Me.GP_Carcelarios, SqlDbType.Bit, False)
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("GP_MadresComuni", Me.GP_MadresComuni, SqlDbType.Bit, False)
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("GP_Otros", Me.GP_Otros, SqlDbType.Bit, False)
            Objparametros.Add(ObjItems)

            If Me.FuenteInformacion <> 0 Then
                ObjItems = New CmdParametro("FuenteInformacion", Me.FuenteInformacion, SqlDbType.Int, False)
            Else
                ObjItems = New CmdParametro("FuenteInformacion", DBNull.Value, SqlDbType.Int, False)
            End If
            Objparametros.Add(ObjItems)

            If Me.IdtblSivigilaDCPaisesISO3166 <> 0 Then
                ObjItems = New CmdParametro("IdtblSivigilaDCPaisesISO3166", Me.IdtblSivigilaDCPaisesISO3166, SqlDbType.Int, False)
            Else
                ObjItems = New CmdParametro("IdtblSivigilaDCPaisesISO3166", DBNull.Value, SqlDbType.Int, False)
            End If
            Objparametros.Add(ObjItems)

            If Me.IdTblDepartamentoProcedencia <> 0 Then
                ObjItems = New CmdParametro("IdTblDepartamentoProcedencia", Me.IdTblDepartamentoProcedencia, SqlDbType.Int, False)
            Else
                ObjItems = New CmdParametro("IdTblDepartamentoProcedencia", DBNull.Value, SqlDbType.Int, False)
            End If
            Objparametros.Add(ObjItems)

            If Me.IdTblMunicipioProcedencia <> 0 Then
                ObjItems = New CmdParametro("IdTblMunicipioProcedencia", Me.IdTblMunicipioProcedencia, SqlDbType.Int, False)
            Else
                ObjItems = New CmdParametro("IdTblMunicipioProcedencia", DBNull.Value, SqlDbType.Int, False)
            End If
            Objparametros.Add(ObjItems)

            If Me.Id_AreaProcedencia <> 0 Then
                ObjItems = New CmdParametro("Id_AreaProcedencia", Me.Id_AreaProcedencia, SqlDbType.Char, 1, False)
            Else
                ObjItems = New CmdParametro("Id_AreaProcedencia", DBNull.Value, SqlDbType.Char, 1, False)
            End If
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("direccionUTI", Me.direccionUTI, SqlDbType.VarChar, 120, False)
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("X_Proced", Me.X_Proced, SqlDbType.Decimal, False)
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("Y_Proced", Me.Y_Proced, SqlDbType.Decimal, False)
            Objparametros.Add(ObjItems)

            If Me.Id_LocalidadProced <> 0 Then
                ObjItems = New CmdParametro("Id_LocalidadProced", Me.Id_LocalidadProced, SqlDbType.Int, False)
            Else
                ObjItems = New CmdParametro("Id_LocalidadProced", DBNull.Value, SqlDbType.Int, False)
            End If
            Objparametros.Add(ObjItems)

            If Me.Id_BarrioProced <> 0 Then
                ObjItems = New CmdParametro("Id_BarrioProced", Me.Id_BarrioProced, SqlDbType.Int, False)
            Else
                ObjItems = New CmdParametro("Id_BarrioProced", DBNull.Value, SqlDbType.Int, False)
            End If
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("BarrioOcurrDigitado", Me.BarrioOcurrDigitado, SqlDbType.VarChar, 70, False)
            Objparametros.Add(ObjItems)

            If Me.Id_tblupzProced <> 0 Then
                ObjItems = New CmdParametro("Id_tblupzProced", Me.Id_tblupzProced, SqlDbType.Int, False)
            Else
                ObjItems = New CmdParametro("Id_tblupzProced", DBNull.Value, SqlDbType.Int, False)
            End If
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("veredaZona", Me.veredaZona, SqlDbType.VarChar, 70, False)
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("nombreUTI", Me.nombreUTI, SqlDbType.VarChar, 100, False)
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("telefonoUTI", Me.telefonoUTI, SqlDbType.Char, 12, False)
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("celularUTI", Me.celularUTI, SqlDbType.VarChar, 15, False)
            Objparametros.Add(ObjItems)

            If Me.FechaConsulta <> "" Then
                ObjItems = New CmdParametro("@FechaConsulta", CDate(Me.FechaConsulta), SqlDbType.SmallDateTime, False)
            Else
                ObjItems = New CmdParametro("@FechaConsulta", DBNull.Value, SqlDbType.SmallDateTime, False)
            End If
            Objparametros.Add(ObjItems)

            If Me.FechaSintomas <> "" Then
                ObjItems = New CmdParametro("@FechaSintomas", CDate(Me.FechaSintomas), SqlDbType.SmallDateTime, False)
            Else
                ObjItems = New CmdParametro("@FechaSintomas", DBNull.Value, SqlDbType.SmallDateTime, False)
            End If
            Objparametros.Add(ObjItems)

            If Not String.IsNullOrEmpty(Me.CodigoCIE10) Then
                ObjItems = New CmdParametro("CodigoCIE10", Me.CodigoCIE10, SqlDbType.VarChar, 255, False)
            Else
                ObjItems = New CmdParametro("CodigoCIE10", DBNull.Value, SqlDbType.VarChar, 255, False)
            End If
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("DescripcionEvento", Me.DescripcionEvento, SqlDbType.VarChar, 5000, False)
            Objparametros.Add(ObjItems)

            If Me.Id_ClasificacionCaso <> 0 Then
                ObjItems = New CmdParametro("Id_ClasificacionCaso", Me.Id_ClasificacionCaso, SqlDbType.Char, 10, False)
            Else
                ObjItems = New CmdParametro("Id_ClasificacionCaso", DBNull.Value, SqlDbType.Char, 10, False)
            End If
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("Hospitalizado", Me.Hospitalizado, SqlDbType.TinyInt, False)
            Objparametros.Add(ObjItems)

            If Me.FechaHospitalizacion <> "" Then
                ObjItems = New CmdParametro("@FechaHospitalizacion", CDate(Me.FechaHospitalizacion), SqlDbType.SmallDateTime, False)
            Else
                ObjItems = New CmdParametro("@FechaHospitalizacion", DBNull.Value, SqlDbType.SmallDateTime, False)
            End If
            Objparametros.Add(ObjItems)

            If Me.CondicionFinal <> 0 Then
                ObjItems = New CmdParametro("CondicionFinal", Me.CondicionFinal, SqlDbType.Char, 4, False)
            Else
                ObjItems = New CmdParametro("CondicionFinal", DBNull.Value, SqlDbType.Char, 4, False)
            End If
            Objparametros.Add(ObjItems)

            If Me.FechaDefuncion <> "" Then
                ObjItems = New CmdParametro("@FechaDefuncion", CDate(Me.FechaDefuncion), SqlDbType.SmallDateTime, False)
            Else
                ObjItems = New CmdParametro("@FechaDefuncion", DBNull.Value, SqlDbType.SmallDateTime, False)
            End If
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("CertificadoDefuncion", Me.CertificadoDefuncion, SqlDbType.Char, 10, False)
            Objparametros.Add(ObjItems)

            If Me.CausaBasica <> "0" Then
                ObjItems = New CmdParametro("CausaBasica", Me.CausaBasica, SqlDbType.VarChar, 4, False)
            Else
                ObjItems = New CmdParametro("CausaBasica", DBNull.Value, SqlDbType.VarChar, 4, False)
            End If
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("NombreProfesional", Me.NombreProfesional, SqlDbType.VarChar, 50, False)
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("TelefonoProfesional", Me.TelefonoProfesional, SqlDbType.VarChar, 20, False)
            Objparametros.Add(ObjItems)

            If Me.CuentaconArl <> 0 Then
                ObjItems = New CmdParametro("CuentaconArl", Me.CuentaconArl, SqlDbType.Char, 1, False)
            Else
                ObjItems = New CmdParametro("CuentaconArl", DBNull.Value, SqlDbType.Char, 1, False)
            End If
            Objparametros.Add(ObjItems)

            If Me.CuentaDocIdentidad <> 0 Then
                ObjItems = New CmdParametro("CuentaDocIdentidad", Me.CuentaDocIdentidad, SqlDbType.Char, 1, False)
            Else
                ObjItems = New CmdParametro("CuentaDocIdentidad", DBNull.Value, SqlDbType.Char, 1, False)
            End If
            Objparametros.Add(ObjItems)

            If Me.CuentaNombres <> 0 Then
                ObjItems = New CmdParametro("CuentaNombres", Me.CuentaNombres, SqlDbType.Char, 1, False)
            Else
                ObjItems = New CmdParametro("CuentaNombres", DBNull.Value, SqlDbType.Char, 1, False)
            End If
            Objparametros.Add(ObjItems)

            If Me.CuentaDireccionTelefono <> 0 Then
                ObjItems = New CmdParametro("CuentaDireccionTelefono", Me.CuentaDireccionTelefono, SqlDbType.Char, 1, False)
            Else
                ObjItems = New CmdParametro("CuentaDireccionTelefono", DBNull.Value, SqlDbType.Char, 1, False)
            End If
            Objparametros.Add(ObjItems)

            If Me.CumpleDatCompl <> 0 Then
                ObjItems = New CmdParametro("CumpleDatCompl", Me.CumpleDatCompl, SqlDbType.Char, 1, False)
            Else
                ObjItems = New CmdParametro("CumpleDatCompl", DBNull.Value, SqlDbType.Char, 1, False)
            End If
            Objparametros.Add(ObjItems)

            If Me.CategoriaUTlsAE <> 0 Then
                ObjItems = New CmdParametro("CategoriaUTlsAE", Me.CategoriaUTlsAE, SqlDbType.Int, False)
            Else
                ObjItems = New CmdParametro("CategoriaUTlsAE", DBNull.Value, SqlDbType.Int, False)
            End If
            Objparametros.Add(ObjItems)

            If CalificacionPrioridad <> 0 Then
                ObjItems = New CmdParametro("CalificacionPrioridad", Me.CalificacionPrioridad, SqlDbType.Int, False)
            Else
                ObjItems = New CmdParametro("CalificacionPrioridad", DBNull.Value, SqlDbType.Int, False)
            End If
            Objparametros.Add(ObjItems)

            If Me.ProgramarVisita <> 0 Then
                ObjItems = New CmdParametro("ProgramarVisita", Me.ProgramarVisita, SqlDbType.TinyInt, False)
            Else
                ObjItems = New CmdParametro("ProgramarVisita", DBNull.Value, SqlDbType.TinyInt, False)
            End If
            Objparametros.Add(ObjItems)

            If Me.FechaUltimaVisitaIEC <> "" Then
                ObjItems = New CmdParametro("@FechaUltimaVisitaIEC", CDate(Me.FechaUltimaVisitaIEC), SqlDbType.SmallDateTime, False)
            Else
                ObjItems = New CmdParametro("@FechaUltimaVisitaIEC", DBNull.Value, SqlDbType.SmallDateTime, False)
            End If
            Objparametros.Add(ObjItems)

            If Me.ResultadoVisita <> 0 Then
                ObjItems = New CmdParametro("ResultadoVisita", Me.ResultadoVisita, SqlDbType.Int, False)
            Else
                ObjItems = New CmdParametro("ResultadoVisita", DBNull.Value, SqlDbType.Int, False)
            End If
            Objparametros.Add(ObjItems)

            If Me.motivoCasoDescartado <> 0 Then
                ObjItems = New CmdParametro("motivoCasoDescartado", Me.motivoCasoDescartado, SqlDbType.Int, False)
            Else
                ObjItems = New CmdParametro("motivoCasoDescartado", DBNull.Value, SqlDbType.Int, False)
            End If
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("CualOtroCasoDescartado", Me.CualOtroCasoDescartado, SqlDbType.VarChar, 50, False)
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("ObservacionesNotDatComple", Me.ObservacionesNotDatComple, SqlDbType.VarChar, 5000, False)
            Objparametros.Add(ObjItems)

            If Me.AccidenteDatCompl <> 0 Then
                ObjItems = New CmdParametro("AccidenteDatCompl", Me.AccidenteDatCompl, SqlDbType.TinyInt, False)
            Else
                ObjItems = New CmdParametro("AccidenteDatCompl", DBNull.Value, SqlDbType.TinyInt, False)
            End If
            Objparametros.Add(ObjItems)

            If Me.EnfermedadDatCompl <> 0 Then
                ObjItems = New CmdParametro("EnfermedadDatCompl", Me.EnfermedadDatCompl, SqlDbType.TinyInt, False)
            Else
                ObjItems = New CmdParametro("EnfermedadDatCompl", DBNull.Value, SqlDbType.TinyInt, False)
            End If
            Objparametros.Add(ObjItems)

            If Me.CQuimicoDatCompl <> 0 Then
                ObjItems = New CmdParametro("CQuimicoDatCompl", Me.CQuimicoDatCompl, SqlDbType.TinyInt, False)
            Else
                ObjItems = New CmdParametro("CQuimicoDatCompl", DBNull.Value, SqlDbType.TinyInt, False)
            End If
            Objparametros.Add(ObjItems)

            If Me.CBiomecanicaDatCompl <> 0 Then
                ObjItems = New CmdParametro("CBiomecanicaDatCompl", Me.CBiomecanicaDatCompl, SqlDbType.TinyInt, False)
            Else
                ObjItems = New CmdParametro("CBiomecanicaDatCompl", DBNull.Value, SqlDbType.TinyInt, False)
            End If

            Objparametros.Add(ObjItems)

            If Me.CAgroquimicoDatCompl <> 0 Then
                ObjItems = New CmdParametro("CAgroquimicoDatCompl", Me.CAgroquimicoDatCompl, SqlDbType.TinyInt, False)
            Else
                ObjItems = New CmdParametro("CAgroquimicoDatCompl", DBNull.Value, SqlDbType.TinyInt, False)
            End If
            Objparametros.Add(ObjItems)

            If Me.OtroEventoDatCompl <> 0 Then
                ObjItems = New CmdParametro("OtroEventoDatCompl", Me.OtroEventoDatCompl, SqlDbType.TinyInt, False)
            Else
                ObjItems = New CmdParametro("OtroEventoDatCompl", DBNull.Value, SqlDbType.TinyInt, False)
            End If

            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("OtroEventoCualDatCompl", Me.OtroEventoCualDatCompl, SqlDbType.VarChar, 50, False)
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("HallaRecoSugeDatCompl", Me.HallaRecoSugeDatCompl, SqlDbType.VarChar, 5000, False)
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("@FuenteRutinaria", Me.FuenteRutinaria, SqlDbType.Bit, False)
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("@FuenteInst", Me.FuenteInst, SqlDbType.Bit, False)
            Objparametros.Add(ObjItems)

            ObjItems = New CmdParametro("@FuenteComu", Me.FuenteComu, SqlDbType.Bit, False)
            Objparametros.Add(ObjItems)



            Dim Insert As String = ""

            If InsertarPersonaSIVISTRA = "" Then
                ObjItems = New CmdParametro("@InsertarPersona", DBNull.Value, SqlDbType.Int, False)
                Objparametros.Add(ObjItems)
                Insert = InsertarbaseSIVISTRA("dbo.spInsertTblNotificacionSivistra", Objparametros)
                'Insert = clsBitacora.Insert("dbo.spInsertTblNotificacionSivistra", Objparametros, objSession, 278, False)
                If Insert <= 0 Then
                    oResp.CodError = -198
                    oResp.TextoError = "Se ha generado un error al grabar. Avise a sistemas para revisar bitacora"
                    Return oResp
                End If

            Else
                ObjItems = New CmdParametro("@InsertarPersona", CInt(InsertarPersonaSIVISTRA), SqlDbType.Int, False)
                Objparametros.Add(ObjItems)
                Insert = InsertarbaseSIVISTRA("dbo.spInsertTblNotificacionSivistra", Objparametros)
                'Insert = clsBitacora.Insert("dbo.spInsertTblNotificacionSivistra", Objparametros, objSession, 278, False)
                If Insert <= 0 Then
                    oResp.CodError = -198
                    oResp.TextoError = "Se ha generado un error al grabar. Avise a sistemas para revisar bitacora"
                    Return oResp
                End If
            End If

        Catch ex As Exception
            oResp.CodError = -199
            oResp.TextoError = ex.Message
        End Try

        Return oResp
    End Function

    Public Shared Function InsertarbaseSIVISTRA(ByVal Procedimiento As String, ByVal Parametros As Collection) As String
        'inicio ----------------------------------------------
        Dim _MsgError As String = ""
        Try
            Dim conn As New SqlConnection()
            conn.ConnectionString = ConfigurationManager.ConnectionStrings("VIGIAConnectionString").ConnectionString
            'conn.ConnectionString = "Server=SDSPRUEBD1\PRUEBASSQL2014,27849;Database=RCVigilancia;Trusted_Connection=Yes;"
            conn.Open()

            If ((conn.State And ConnectionState.Open) > 0) Then

                'ScriptManager.RegisterStartupScript(Me, Me.Page.GetType, "myFuncionAlert", "window.alert('todo ok')", True)
                Dim cmd As New SqlCommand()
                cmd.Connection = conn
                cmd.CommandType = CommandType.StoredProcedure
                cmd.CommandText = Procedimiento
                Dim objparametros As CmdParametro
                '------------------------
                Dim Parametro As SqlParameter
                ' Recorre la coleccion de parametros
                For Each objparametros In Parametros
                    Parametro = New SqlParameter
                    Parametro.ParameterName = objparametros.Nombre
                    Parametro.SqlDbType = objparametros.Tipo
                    Parametro.Value = objparametros.Valor

                    cmd.Parameters.Add(Parametro)

                Next

                Dim Ejecucion As Integer

                Ejecucion = cmd.ExecuteScalar

                _MsgError = Ejecucion
                conn.Close()
                conn.Dispose()
            End If
        Catch ex As Exception
            _MsgError = ex.Message
            Return _MsgError
        Finally

        End Try
        Return _MsgError
    End Function

    Private Function validarPersonaSIVISTRA(ByVal nombre1 As String, ByVal nombre2 As String, ByVal apellido1 As String, ByVal apellido2 As String, ByVal NumeroDoc As String, ByVal id_TipoDoc As Integer, ByVal FechaNacimiento As DateTime) As String

        Dim objSession As HttpSessionState = HttpContext.Current.Session

        Dim Objparametros As New Collection

        Dim ObjItems As New CmdParametro("@PrimerNombre", PrimerNombre, SqlDbType.VarChar, False, 20)
        Objparametros.Add(ObjItems)

        If nombre2 = "" Then
            ObjItems = New CmdParametro("@SegundoNombre", DBNull.Value, SqlDbType.VarChar, False, 30)
            Objparametros.Add(ObjItems)
        Else
            ObjItems = New CmdParametro("@SegundoNombre", nombre2, SqlDbType.VarChar, False, 30)
            Objparametros.Add(ObjItems)
        End If


        ObjItems = New CmdParametro("@PrimerApellido", PrimerApellido, SqlDbType.VarChar, False, 20)
        Objparametros.Add(ObjItems)

        If apellido2 = "" Then
            ObjItems = New CmdParametro("@SegundoApellido", DBNull.Value, SqlDbType.VarChar, False, 30)
            Objparametros.Add(ObjItems)
        Else
            ObjItems = New CmdParametro("@SegundoApellido", SegundoApellido, SqlDbType.VarChar, False, 30)
            Objparametros.Add(ObjItems)
        End If


        ObjItems = New CmdParametro("@NroIdentificacion", NroIdentificacion, SqlDbType.Char, False, 21)
        Objparametros.Add(ObjItems)


        ObjItems = New CmdParametro("@id_TipoIdentificacion", id_TipoIdentificacion, SqlDbType.Int, False)
        Objparametros.Add(ObjItems)

        ObjItems = New CmdParametro("@FechaNacimiento", FechaNacimiento, SqlDbType.SmallDateTime, False)
        Objparametros.Add(ObjItems)


        Dim cont As String = clsBitacora.GetEscalar("dbo.spGetValidarPersonaSIVISTRA", Objparametros, objSession, 200, False).ToString

        Return cont

    End Function

#End Region


End Class
